Pandas Profiling Report

Dataset statistics

Number of variables	28
Number of observations	115609
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	269
Duplicate rows (%)	0.2%
Total size in memory	24.7 MiB
Average record size in memory	224.0 B

Variable types

Text	9
Categorical	4
Numeric	14
DateTime	1

Alerts

Dataset has 269 (0.2%) duplicate rows	Duplicates
`payment_value` is highly overall correlated with `price`	High correlation
`customer_zip_code_prefix` is highly overall correlated with `customer_state`	High correlation
`price` is highly overall correlated with `payment_value` and 1 other fields	High correlation
`product_weight_g` is highly overall correlated with `price` and 3 other fields	High correlation
`product_length_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`product_height_cm` is highly overall correlated with `product_weight_g`	High correlation
`product_width_cm` is highly overall correlated with `product_weight_g` and 1 other fields	High correlation
`customer_state` is highly overall correlated with `customer_zip_code_prefix`	High correlation
`order_status` is highly imbalanced (93.4%)	Imbalance

Reproduction

Analysis started	2024-04-25 02:24:35.804559
Analysis finished	2024-04-25 02:24:53.716036
Duration	17.91 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

order_id
Text

Distinct	96516
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3699488
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83927 ?
Unique (%)	72.6%

Sample

1st row	e481f51cbdc54678b7cc49136f2d6af7
2nd row	e481f51cbdc54678b7cc49136f2d6af7
3rd row	e481f51cbdc54678b7cc49136f2d6af7
4th row	128e10d95713541c87cd1a2e48201934
5th row	0e7e841ddf8f8f2de2bad69267ecfbcf

Value	Count	Frequency (%)
895ab968e7bb0d5659d16cd74cd1650c	63	0.1%
fedcd9f7ccdc8cba3a18defedd1a5547	38	< 0.1%
fa65dad1b0e818e3ccc5cb0e39231352	29	< 0.1%
ccf804e764ed5650cd8759557269dc13	26	< 0.1%
68986e4324f6a21481df4e6e89abcf01	24	< 0.1%
c6492b842ac190db807c15aff21a7dd6	24	< 0.1%
465c2e1bee4561cb39e0db8c5993aafc	24	< 0.1%
a3725dfe487d359b5be08cac48b64ec5	24	< 0.1%
6d58638e32674bebee793a47ac4cbadc	24	< 0.1%
285c2e15bebd4ac83635ccc563dc71f4	22	< 0.1%
Other values (96506)	115311	99.7%

Most occurring characters

Value	Count	Frequency (%)
4	232347	6.3%
b	232260	6.3%
6	232183	6.3%
e	231974	6.3%
c	231513	6.3%
3	231489	6.3%
1	231448	6.3%
7	231435	6.3%
8	231366	6.3%
a	231122	6.2%
Other values (6)	1382351	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2311582	62.5%
Lowercase Letter	1387906	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	232347	10.1%
6	232183	10.0%
3	231489	10.0%
1	231448	10.0%
7	231435	10.0%
8	231366	10.0%
2	230768	10.0%
9	230559	10.0%
0	230074	10.0%
5	229913	9.9%

Lowercase Letter

Value	Count	Frequency (%)
b	232260	16.7%
e	231974	16.7%
c	231513	16.7%
a	231122	16.7%
f	230865	16.6%
d	230172	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2311582	62.5%
Latin	1387906	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	232347	10.1%
6	232183	10.0%
3	231489	10.0%
1	231448	10.0%
7	231435	10.0%
8	231366	10.0%
2	230768	10.0%
9	230559	10.0%
0	230074	10.0%
5	229913	9.9%

Latin

Value	Count	Frequency (%)
b	232260	16.7%
e	231974	16.7%
c	231513	16.7%
a	231122	16.7%
f	230865	16.6%
d	230172	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3699488	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	232347	6.3%
b	232260	6.3%
6	232183	6.3%
e	231974	6.3%
c	231513	6.3%
3	231489	6.3%
1	231448	6.3%
7	231435	6.3%
8	231366	6.3%
a	231122	6.2%
Other values (6)	1382351	37.4%

customer_id
Text

Distinct	96516
Distinct (%)	83.5%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3699488
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	83927 ?
Unique (%)	72.6%

Sample

1st row	9ef432eb6251297304e76186b10a928d
2nd row	9ef432eb6251297304e76186b10a928d
3rd row	9ef432eb6251297304e76186b10a928d
4th row	a20e8105f23924cd00833fd87daa0831
5th row	26c7ac168e1433912a51b924fbd34d34

Value	Count	Frequency (%)
270c23a11d024a44c896d1894b261a83	63	0.1%
13aa59158da63ba0e93ec6ac2c07aacb	38	< 0.1%
9af2372a1e49340278e7c1ef8d749f34	29	< 0.1%
92cd3ec6e2d643d4ebd0e3d6238f69e2	26	< 0.1%
86cc80fef09f7f39df4b0dbce48e81cb	24	< 0.1%
6ee2f17e3b6c33d6a9557f280edd2925	24	< 0.1%
63b964e79dee32a3587651701a2b8dbf	24	< 0.1%
d22f25a9fadfb1abbc2e29395b1239f4	24	< 0.1%
2ba91e12e5e4c9f56b82b86d9031d329	24	< 0.1%
b246eeed30b362c09d867b9e598bee51	22	< 0.1%
Other values (96506)	115311	99.7%

Most occurring characters

Value	Count	Frequency (%)
2	231848	6.3%
f	231815	6.3%
5	231684	6.3%
c	231607	6.3%
6	231574	6.3%
1	231546	6.3%
e	231206	6.2%
8	231191	6.2%
a	231174	6.2%
d	231155	6.2%
Other values (6)	1384688	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2311390	62.5%
Lowercase Letter	1388098	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	231848	10.0%
5	231684	10.0%
6	231574	10.0%
1	231546	10.0%
8	231191	10.0%
9	231116	10.0%
3	231114	10.0%
7	231035	10.0%
4	230174	10.0%
0	230108	10.0%

Lowercase Letter

Value	Count	Frequency (%)
f	231815	16.7%
c	231607	16.7%
e	231206	16.7%
a	231174	16.7%
d	231155	16.7%
b	231141	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	2311390	62.5%
Latin	1388098	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	231848	10.0%
5	231684	10.0%
6	231574	10.0%
1	231546	10.0%
8	231191	10.0%
9	231116	10.0%
3	231114	10.0%
7	231035	10.0%
4	230174	10.0%
0	230108	10.0%

Latin

Value	Count	Frequency (%)
f	231815	16.7%
c	231607	16.7%
e	231206	16.7%
a	231174	16.7%
d	231155	16.7%
b	231141	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3699488	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	231848	6.3%
f	231815	6.3%
5	231684	6.3%
c	231607	6.3%
6	231574	6.3%
1	231546	6.3%
e	231206	6.2%
8	231191	6.2%
a	231174	6.2%
d	231155	6.2%
Other values (6)	1384688	37.4%

order_status
Categorical

IMBALANCE

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

delivered	113210
shipped	1138
canceled	536
invoiced	358
processing	357
Other values (2)	10

Length

Max length	11
Median length	9
Mean length	8.9757631
Min length	7

Characters and Unicode

Total characters	1037679
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	delivered
2nd row	delivered
3rd row	delivered
4th row	delivered
5th row	delivered

Common Values

Value	Count	Frequency (%)
delivered	113210	97.9%
shipped	1138	1.0%
canceled	536	0.5%
invoiced	358	0.3%
processing	357	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
delivered	113210	97.9%
shipped	1138	1.0%
canceled	536	0.5%
invoiced	358	0.3%
processing	357	0.3%
unavailable	7	< 0.1%
approved	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	342565	33.0%
d	228455	22.0%
i	115428	11.1%
l	113760	11.0%
v	113578	10.9%
r	113570	10.9%
p	2639	0.3%
s	1852	0.2%
c	1787	0.2%
n	1258	0.1%
Other values (6)	2787	0.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1037679	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	342565	33.0%
d	228455	22.0%
i	115428	11.1%
l	113760	11.0%
v	113578	10.9%
r	113570	10.9%
p	2639	0.3%
s	1852	0.2%
c	1787	0.2%
n	1258	0.1%
Other values (6)	2787	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1037679	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	342565	33.0%
d	228455	22.0%
i	115428	11.1%
l	113760	11.0%
v	113578	10.9%
r	113570	10.9%
p	2639	0.3%
s	1852	0.2%
c	1787	0.2%
n	1258	0.1%
Other values (6)	2787	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1037679	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	342565	33.0%
d	228455	22.0%
i	115428	11.1%
l	113760	11.0%
v	113578	10.9%
r	113570	10.9%
p	2639	0.3%
s	1852	0.2%
c	1787	0.2%
n	1258	0.1%
Other values (6)	2787	0.3%

payment_sequential
Real number (ℝ)

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.093747

Minimum	1
Maximum	29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	29
Range	28
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.72984871
Coefficient of variation (CV)	0.66729206
Kurtosis	350.44021
Mean	1.093747
Median Absolute Deviation (MAD)	0
Skewness	16.001768
Sum	126447
Variance	0.53267914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
1	110662	95.7%
2	3298	2.9%
3	636	0.6%
4	307	0.3%
5	183	0.2%
6	127	0.1%
7	88	0.1%
8	58	0.1%
9	47	< 0.1%
10	40	< 0.1%
Other values (19)	163	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	110662	95.7%
2	3298	2.9%
3	636	0.6%
4	307	0.3%
5	183	0.2%
6	127	0.1%
7	88	0.1%
8	58	0.1%
9	47	< 0.1%
10	40	< 0.1%

Value	Count	Frequency (%)
29	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	2	< 0.1%
25	2	< 0.1%
24	2	< 0.1%
23	2	< 0.1%
22	3	< 0.1%
21	6	< 0.1%
20	6	< 0.1%

payment_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

credit_card	85278
boleto	22510
voucher	6162
debit_card	1659

Length

Max length	11
Median length	11
Mean length	9.7989084
Min length	6

Characters and Unicode

Total characters	1132842
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	credit_card
2nd row	voucher
3rd row	voucher
4th row	credit_card
5th row	credit_card

Common Values

Value	Count	Frequency (%)
credit_card	85278	73.8%
boleto	22510	19.5%
voucher	6162	5.3%
debit_card	1659	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
credit_card	85278	73.8%
boleto	22510	19.5%
voucher	6162	5.3%
debit_card	1659	1.4%

Most occurring characters

Value	Count	Frequency (%)
c	178377	15.7%
r	178377	15.7%
d	173874	15.3%
e	115609	10.2%
t	109447	9.7%
i	86937	7.7%
_	86937	7.7%
a	86937	7.7%
o	51182	4.5%
b	24169	2.1%
Other values (4)	40996	3.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1045905	92.3%
Connector Punctuation	86937	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	178377	17.1%
r	178377	17.1%
d	173874	16.6%
e	115609	11.1%
t	109447	10.5%
i	86937	8.3%
a	86937	8.3%
o	51182	4.9%
b	24169	2.3%
l	22510	2.2%
Other values (3)	18486	1.8%

Connector Punctuation

Value	Count	Frequency (%)
_	86937	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1045905	92.3%
Common	86937	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	178377	17.1%
r	178377	17.1%
d	173874	16.6%
e	115609	11.1%
t	109447	10.5%
i	86937	8.3%
a	86937	8.3%
o	51182	4.9%
b	24169	2.3%
l	22510	2.2%
Other values (3)	18486	1.8%

Common

Value	Count	Frequency (%)
_	86937	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1132842	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	178377	15.7%
r	178377	15.7%
d	173874	15.3%
e	115609	10.2%
t	109447	9.7%
i	86937	7.7%
_	86937	7.7%
a	86937	7.7%
o	51182	4.5%
b	24169	2.1%
Other values (4)	40996	3.6%

payment_installments
Real number (ℝ)

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.9462326

Minimum	0
Maximum	24
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	10
Maximum	24
Range	24
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.7810871
Coefficient of variation (CV)	0.94394691
Kurtosis	2.5137681
Mean	2.9462326
Median Absolute Deviation (MAD)	1
Skewness	1.6181717
Sum	340611
Variance	7.7344456
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
1	57599	49.8%
2	13404	11.6%
3	11551	10.0%
4	7855	6.8%
10	6785	5.9%
5	5928	5.1%
8	5013	4.3%
6	4546	3.9%
7	1789	1.5%
9	710	0.6%
Other values (14)	429	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	57599	49.8%
2	13404	11.6%
3	11551	10.0%
4	7855	6.8%
5	5928	5.1%
6	4546	3.9%
7	1789	1.5%
8	5013	4.3%
9	710	0.6%

Value	Count	Frequency (%)
24	34	< 0.1%
23	1	< 0.1%
22	1	< 0.1%
21	6	< 0.1%
20	20	< 0.1%
18	38	< 0.1%
17	7	< 0.1%
16	7	< 0.1%
15	91	0.1%
14	16	< 0.1%

payment_value
Real number (ℝ)

HIGH CORRELATION

Distinct	28657
Distinct (%)	24.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	172.38738

Minimum	0
Maximum	13664.08
Zeros	6
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	0
5-th percentile	27.23
Q1	60.87
median	108.05
Q3	189.48
95-th percentile	514.98
Maximum	13664.08
Range	13664.08
Interquartile range (IQR)	128.61

Descriptive statistics

Standard deviation	265.87397
Coefficient of variation (CV)	1.5423053
Kurtosis	524.94523
Mean	172.38738
Median Absolute Deviation (MAD)	56.67
Skewness	14.306544
Sum	19929533
Variance	70688.967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	338	0.3%
100	285	0.2%
20	283	0.2%
77.57	249	0.2%
35	163	0.1%
73.34	157	0.1%
30	134	0.1%
116.94	130	0.1%
56.78	120	0.1%
155.14	119	0.1%
Other values (28647)	113631	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	< 0.1%
0.01	6	< 0.1%
0.03	2	< 0.1%
0.05	2	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	2	< 0.1%
0.13	1	< 0.1%
0.14	4	< 0.1%

Value	Count	Frequency (%)
13664.08	8	< 0.1%
7274.88	4	< 0.1%
6929.31	1	< 0.1%
6726.66	1	< 0.1%
6081.54	6	< 0.1%
4950.34	1	< 0.1%
4809.44	2	< 0.1%
4764.34	1	< 0.1%
4681.78	1	< 0.1%
4513.32	1	< 0.1%

customer_unique_id
Text

Distinct	93396
Distinct (%)	80.8%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3699488
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	79377 ?
Unique (%)	68.7%

Sample

1st row	7c396fd4830fd04220f754e42b4e5bff
2nd row	7c396fd4830fd04220f754e42b4e5bff
3rd row	7c396fd4830fd04220f754e42b4e5bff
4th row	3a51803cc0d012c3b5dc8b7528cb05f7
5th row	ef0996a1a279c26e7ecbd737be23d235

Value	Count	Frequency (%)
9a736b248f67d166d2fbb006bcb877c3	75	0.1%
6fbc7cdadbb522125f4b27ae9dee4060	38	< 0.1%
f9ae226291893fda10af7965268fb7f6	35	< 0.1%
8af7ac63b2efbcbd88e5b11505e8098a	29	< 0.1%
569aa12b73b5f7edeaa6f2a01603e381	26	< 0.1%
db1af3fd6b23ac3873ef02619d548f9c	24	< 0.1%
90807fdb59eec2152bc977feeb6e47e7	24	< 0.1%
d97b3cfb22b0d6b25ac9ed4e9c2d481b	24	< 0.1%
1d2435aa3b858d45c707c9fc25e18779	24	< 0.1%
5419a7c9b86a43d8140e2939cd2c2f7e	24	< 0.1%
Other values (93386)	115286	99.7%

Most occurring characters

Value	Count	Frequency (%)
6	232253	6.3%
b	231885	6.3%
1	231813	6.3%
a	231488	6.3%
d	231353	6.3%
3	231341	6.3%
e	231271	6.3%
8	231179	6.2%
2	231112	6.2%
5	231087	6.2%
Other values (6)	1384706	37.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2312012	62.5%
Lowercase Letter	1387476	37.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	232253	10.0%
1	231813	10.0%
3	231341	10.0%
8	231179	10.0%
2	231112	10.0%
5	231087	10.0%
9	231084	10.0%
7	231012	10.0%
0	230821	10.0%
4	230310	10.0%

Lowercase Letter

Value	Count	Frequency (%)
b	231885	16.7%
a	231488	16.7%
d	231353	16.7%
e	231271	16.7%
f	230923	16.6%
c	230556	16.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2312012	62.5%
Latin	1387476	37.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	232253	10.0%
1	231813	10.0%
3	231341	10.0%
8	231179	10.0%
2	231112	10.0%
5	231087	10.0%
9	231084	10.0%
7	231012	10.0%
0	230821	10.0%
4	230310	10.0%

Latin

Value	Count	Frequency (%)
b	231885	16.7%
a	231488	16.7%
d	231353	16.7%
e	231271	16.7%
f	230923	16.6%
c	230556	16.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3699488	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	232253	6.3%
b	231885	6.3%
1	231813	6.3%
a	231488	6.3%
d	231353	6.3%
3	231341	6.3%
e	231271	6.3%
8	231179	6.2%
2	231112	6.2%
5	231087	6.2%
Other values (6)	1384706	37.4%

customer_zip_code_prefix
Real number (ℝ)

HIGH CORRELATION

Distinct	14907
Distinct (%)	12.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35061.538

Minimum	1003
Maximum	99980
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	1003
5-th percentile	3286
Q1	11310
median	24241
Q3	58745
95-th percentile	90620
Maximum	99980
Range	98977
Interquartile range (IQR)	47435

Descriptive statistics

Standard deviation	29841.672
Coefficient of variation (CV)	0.85112273
Kurtosis	-0.78410177
Mean	35061.538
Median Absolute Deviation (MAD)	16231
Skewness	0.78436422
Sum	4.0534293 × 10⁹
Variance	8.9052537 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24220	154	0.1%
22793	151	0.1%
22790	150	0.1%
24230	138	0.1%
22775	126	0.1%
35162	124	0.1%
29101	112	0.1%
11740	110	0.1%
13087	107	0.1%
36570	104	0.1%
Other values (14897)	114333	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1003	1	< 0.1%
1004	2	< 0.1%
1005	6	< 0.1%
1006	2	< 0.1%
1007	4	< 0.1%
1008	3	< 0.1%
1009	8	< 0.1%
1011	6	< 0.1%
1012	2	< 0.1%
1013	3	< 0.1%

Value	Count	Frequency (%)
99980	3	< 0.1%
99970	1	< 0.1%
99965	2	< 0.1%
99960	1	< 0.1%
99955	3	< 0.1%
99950	9	< 0.1%
99940	2	< 0.1%
99930	5	< 0.1%
99925	1	< 0.1%
99920	1	< 0.1%

customer_city
Text

Distinct	4093
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	32
Median length	27
Mean length	10.332855
Min length	3

Characters and Unicode

Total characters	1194571
Distinct characters	31
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1042 ?
Unique (%)	0.9%

Sample

1st row	sao paulo
2nd row	sao paulo
3rd row	sao paulo
4th row	sao paulo
5th row	sao paulo

Value	Count	Frequency (%)
sao	24620	12.1%
paulo	18348	9.1%
de	11267	5.6%
rio	9627	4.8%
janeiro	8022	4.0%
do	4964	2.4%
belo	3269	1.6%
horizonte	3224	1.6%
brasilia	2444	1.2%
porto	1942	1.0%
Other values (3268)	114916	56.7%

Most occurring characters

Value	Count	Frequency (%)
a	197038	16.5%
o	147371	12.3%
i	91350	7.6%
r	88530	7.4%
	87034	7.3%
e	77539	6.5%
s	73205	6.1%
n	52923	4.4%
u	52440	4.4%
l	52072	4.4%
Other values (21)	275069	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1106996	92.7%
Space Separator	87034	7.3%
Dash Punctuation	281	< 0.1%
Other Punctuation	258	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	197038	17.8%
o	147371	13.3%
i	91350	8.3%
r	88530	8.0%
e	77539	7.0%
s	73205	6.6%
n	52923	4.8%
u	52440	4.7%
l	52072	4.7%
p	43443	3.9%
Other values (16)	231085	20.9%

Decimal Number

Value	Count	Frequency (%)
1	1	50.0%
4	1	50.0%

Space Separator

Value	Count	Frequency (%)
	87034	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	281	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	258	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1106996	92.7%
Common	87575	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	197038	17.8%
o	147371	13.3%
i	91350	8.3%
r	88530	8.0%
e	77539	7.0%
s	73205	6.6%
n	52923	4.8%
u	52440	4.7%
l	52072	4.7%
p	43443	3.9%
Other values (16)	231085	20.9%

Common

Value	Count	Frequency (%)
	87034	99.4%
-	281	0.3%
'	258	0.3%
1	1	< 0.1%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1194571	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	197038	16.5%
o	147371	12.3%
i	91350	7.6%
r	88530	7.4%
	87034	7.3%
e	77539	6.5%
s	73205	6.1%
n	52923	4.4%
u	52440	4.4%
l	52072	4.4%
Other values (21)	275069	23.0%

customer_state
Categorical

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

SP	48797
RJ	14987
MG	13429
RS	6413
PR	5879
Other values (22)	26104

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	231218
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SP
2nd row	SP
3rd row	SP
4th row	SP
5th row	SP

Common Values

Value	Count	Frequency (%)
SP	48797	42.2%
RJ	14987	13.0%
MG	13429	11.6%
RS	6413	5.5%
PR	5879	5.1%
SC	4218	3.6%
BA	3942	3.4%
DF	2449	2.1%
GO	2359	2.0%
ES	2300	2.0%
Other values (17)	10836	9.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sp	48797	42.2%
rj	14987	13.0%
mg	13429	11.6%
rs	6413	5.5%
pr	5879	5.1%
sc	4218	3.6%
ba	3942	3.4%
df	2449	2.1%
go	2359	2.0%
es	2300	2.0%
Other values (17)	10836	9.4%

Most occurring characters

Value	Count	Frequency (%)
S	62966	27.2%
P	58871	25.5%
R	28218	12.2%
M	16380	7.1%
G	15788	6.8%
J	14987	6.5%
A	6654	2.9%
E	6071	2.6%
C	5838	2.5%
B	4561	2.0%
Other values (7)	10884	4.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	231218	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	62966	27.2%
P	58871	25.5%
R	28218	12.2%
M	16380	7.1%
G	15788	6.8%
J	14987	6.5%
A	6654	2.9%
E	6071	2.6%
C	5838	2.5%
B	4561	2.0%
Other values (7)	10884	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	231218	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	62966	27.2%
P	58871	25.5%
R	28218	12.2%
M	16380	7.1%
G	15788	6.8%
J	14987	6.5%
A	6654	2.9%
E	6071	2.6%
C	5838	2.5%
B	4561	2.0%
Other values (7)	10884	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	231218	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	62966	27.2%
P	58871	25.5%
R	28218	12.2%
M	16380	7.1%
G	15788	6.8%
J	14987	6.5%
A	6654	2.9%
E	6071	2.6%
C	5838	2.5%
B	4561	2.0%
Other values (7)	10884	4.7%

order_item_id
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.194535

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	21
Range	20
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.68592588
Coefficient of variation (CV)	0.57421998
Kurtosis	93.440808
Mean	1.194535
Median Absolute Deviation (MAD)	0
Skewness	7.195206
Sum	138099
Variance	0.47049432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	101340	87.7%
2	10055	8.7%
3	2326	2.0%
4	969	0.8%
5	458	0.4%
6	256	0.2%
7	60	0.1%
8	35	< 0.1%
9	28	< 0.1%
10	25	< 0.1%
Other values (11)	57	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	101340	87.7%
2	10055	8.7%
3	2326	2.0%
4	969	0.8%
5	458	0.4%
6	256	0.2%
7	60	0.1%
8	35	< 0.1%
9	28	< 0.1%
10	25	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	2	< 0.1%
19	2	< 0.1%
18	2	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	4	< 0.1%
14	6	< 0.1%
13	7	< 0.1%
12	12	< 0.1%

product_id
Text

Distinct	32171
Distinct (%)	27.8%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3699488
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16932 ?
Unique (%)	14.6%

Sample

1st row	87285b34884572647811a353c7ac498a
2nd row	87285b34884572647811a353c7ac498a
3rd row	87285b34884572647811a353c7ac498a
4th row	87285b34884572647811a353c7ac498a
5th row	87285b34884572647811a353c7ac498a

Value	Count	Frequency (%)
aca2eb7d00ea1a7b8ebd4e68314663af	533	0.5%
99a4788cb24856965c36a24e339b6058	517	0.4%
422879e10f46682990de24d770e7f83d	507	0.4%
389d119b48cf3043d311335e499d9c6b	405	0.4%
368c6c730842d78016ad823897a372db	395	0.3%
53759a2ecddad2bb87a079a1f1519f73	389	0.3%
d1c427060a0f73f6b889a5c7c61f2ac4	354	0.3%
53b36df67ebb7c41585e8d54d6772e08	324	0.3%
154e7e31ebfa092203795c972e5804a6	294	0.3%
3dd2a17168ec895c781a9191c1e95ad7	276	0.2%
Other values (32161)	111615	96.5%

Most occurring characters

Value	Count	Frequency (%)
3	237911	6.4%
9	235951	6.4%
e	233656	6.3%
7	233105	6.3%
8	232719	6.3%
4	231409	6.3%
a	231308	6.3%
c	231075	6.2%
2	230954	6.2%
6	230872	6.2%
Other values (6)	1370528	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2321899	62.8%
Lowercase Letter	1377589	37.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	237911	10.2%
9	235951	10.2%
7	233105	10.0%
8	232719	10.0%
4	231409	10.0%
2	230954	9.9%
6	230872	9.9%
0	230822	9.9%
5	229692	9.9%
1	228464	9.8%

Lowercase Letter

Value	Count	Frequency (%)
e	233656	17.0%
a	231308	16.8%
c	231075	16.8%
b	229587	16.7%
d	227350	16.5%
f	224613	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	2321899	62.8%
Latin	1377589	37.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	237911	10.2%
9	235951	10.2%
7	233105	10.0%
8	232719	10.0%
4	231409	10.0%
2	230954	9.9%
6	230872	9.9%
0	230822	9.9%
5	229692	9.9%
1	228464	9.8%

Latin

Value	Count	Frequency (%)
e	233656	17.0%
a	231308	16.8%
c	231075	16.8%
b	229587	16.7%
d	227350	16.5%
f	224613	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3699488	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	237911	6.4%
9	235951	6.4%
e	233656	6.3%
7	233105	6.3%
8	232719	6.3%
4	231409	6.3%
a	231308	6.3%
c	231075	6.2%
2	230954	6.2%
6	230872	6.2%
Other values (6)	1370528	37.0%

seller_id
Text

Distinct	3028
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	3699488
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	485 ?
Unique (%)	0.4%

Sample

1st row	3504c0cb71d7fa48d967e0e4c94d59d9
2nd row	3504c0cb71d7fa48d967e0e4c94d59d9
3rd row	3504c0cb71d7fa48d967e0e4c94d59d9
4th row	3504c0cb71d7fa48d967e0e4c94d59d9
5th row	3504c0cb71d7fa48d967e0e4c94d59d9

Value	Count	Frequency (%)
4a3ca9315b744ce9f8e9374361493884	2128	1.8%
6560211a19b47992c3666cc44a7e94c0	2111	1.8%
1f50f920176fa81dab994f9023523100	2009	1.7%
cc419e0650a3c5ba77189a1882b7556a	1885	1.6%
da8622b14eb17ae2831f4ac5b9dab84a	1656	1.4%
955fee9216a65b617aa5c0531780ce60	1517	1.3%
1025f0e2d44d7041d6cf58b6550e0bfa	1465	1.3%
7c67e1448b00f6e969d365cea6b010ab	1454	1.3%
7a67c85e85bb2ce8582c35f2203ad736	1236	1.1%
ea8482cd71df3c1969d7b9473ff13abc	1233	1.1%
Other values (3018)	98915	85.6%

Most occurring characters

Value	Count	Frequency (%)
1	251950	6.8%
c	243876	6.6%
4	243091	6.6%
6	238193	6.4%
0	237394	6.4%
a	236721	6.4%
b	235816	6.4%
3	235558	6.4%
9	228810	6.2%
2	227464	6.1%
Other values (6)	1320615	35.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2339688	63.2%
Lowercase Letter	1359800	36.8%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	251950	10.8%
4	243091	10.4%
6	238193	10.2%
0	237394	10.1%
3	235558	10.1%
9	228810	9.8%
2	227464	9.7%
8	226366	9.7%
5	225942	9.7%
7	224920	9.6%

Lowercase Letter

Value	Count	Frequency (%)
c	243876	17.9%
a	236721	17.4%
b	235816	17.3%
e	216428	15.9%
f	214706	15.8%
d	212253	15.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	2339688	63.2%
Latin	1359800	36.8%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	251950	10.8%
4	243091	10.4%
6	238193	10.2%
0	237394	10.1%
3	235558	10.1%
9	228810	9.8%
2	227464	9.7%
8	226366	9.7%
5	225942	9.7%
7	224920	9.6%

Latin

Value	Count	Frequency (%)
c	243876	17.9%
a	236721	17.4%
b	235816	17.3%
e	216428	15.9%
f	214706	15.8%
d	212253	15.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3699488	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	251950	6.8%
c	243876	6.6%
4	243091	6.6%
6	238193	6.4%
0	237394	6.4%
a	236721	6.4%
b	235816	6.4%
3	235558	6.4%
9	228810	6.2%
2	227464	6.1%
Other values (6)	1320615	35.7%

shipping_limit_date
Date

Distinct	91386
Distinct (%)	79.0%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Minimum	2016-09-19 00:15:34
Maximum	2020-04-09 22:35:08

Histogram

Histogram with fixed size bins (bins=50)

price
Real number (ℝ)

HIGH CORRELATION

Distinct	5879
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.61985

Minimum	0.85
Maximum	6735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	0.85
5-th percentile	17
Q1	39.9
median	74.9
Q3	134.9
95-th percentile	349.9
Maximum	6735
Range	6734.15
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	182.65348
Coefficient of variation (CV)	1.5142904
Kurtosis	107.9051
Mean	120.61985
Median Absolute Deviation (MAD)	42
Skewness	7.6154182
Sum	13944740
Variance	33362.292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.9	2574	2.2%
69.9	2096	1.8%
49.9	2013	1.7%
89.9	1604	1.4%
99.9	1505	1.3%
29.9	1362	1.2%
39.9	1325	1.1%
79.9	1266	1.1%
19.9	1263	1.1%
29.99	1204	1.0%
Other values (5869)	99397	86.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.85	3	< 0.1%
1.2	20	< 0.1%
2.2	2	< 0.1%
2.29	1	< 0.1%
2.9	1	< 0.1%
2.99	1	< 0.1%
3.06	3	< 0.1%
3.49	3	< 0.1%
3.5	7	< 0.1%
3.54	1	< 0.1%

Value	Count	Frequency (%)
6735	1	< 0.1%
6499	1	< 0.1%
4799	1	< 0.1%
4690	1	< 0.1%
4590	1	< 0.1%
4399.87	1	< 0.1%
4099.99	1	< 0.1%
4059	1	< 0.1%
3999.9	1	< 0.1%
3999	2	< 0.1%

freight_value
Real number (ℝ)

Distinct	6954
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.05688

Minimum	0
Maximum	409.68
Zeros	387
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	0
5-th percentile	7.78
Q1	13.08
median	16.32
Q3	21.21
95-th percentile	45.31
Maximum	409.68
Range	409.68
Interquartile range (IQR)	8.13

Descriptive statistics

Standard deviation	15.836184
Coefficient of variation (CV)	0.78956371
Kurtosis	58.250048
Mean	20.05688
Median Absolute Deviation (MAD)	3.63
Skewness	5.5602128
Sum	2318755.8
Variance	250.78473
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.1	3754	3.2%
7.78	2281	2.0%
11.85	1948	1.7%
14.1	1939	1.7%
18.23	1599	1.4%
7.39	1554	1.3%
16.11	1185	1.0%
15.23	1041	0.9%
8.72	950	0.8%
16.79	902	0.8%
Other values (6944)	98456	85.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	387	0.3%
0.01	4	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	4	< 0.1%
0.05	3	< 0.1%
0.06	13	< 0.1%
0.07	1	< 0.1%
0.08	12	< 0.1%
0.09	6	< 0.1%

Value	Count	Frequency (%)
409.68	1	< 0.1%
375.28	2	< 0.1%
339.59	1	< 0.1%
338.3	1	< 0.1%
322.1	1	< 0.1%
321.88	1	< 0.1%
321.46	1	< 0.1%
317.47	1	< 0.1%
314.4	1	< 0.1%
314.02	1	< 0.1%

product_category_name
Text

Distinct	71
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	46
Median length	30
Mean length	14.875062
Min length	3

Characters and Unicode

Total characters	1719691
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	utilidades_domesticas
2nd row	utilidades_domesticas
3rd row	utilidades_domesticas
4th row	utilidades_domesticas
5th row	utilidades_domesticas

Value	Count	Frequency (%)
cama_mesa_banho	11847	10.2%
beleza_saude	9944	8.6%
esporte_lazer	8942	7.7%
moveis_decoracao	8743	7.6%
informatica_acessorios	8105	7.0%
utilidades_domesticas	7331	6.3%
relogios_presentes	6161	5.3%
telefonia	4692	4.1%
ferramentas_jardim	4558	3.9%
automotivo	4356	3.8%
Other values (61)	40930	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	208749	12.1%
a	206939	12.0%
s	171469	10.0%
o	170145	9.9%
i	114273	6.6%
r	110581	6.4%
_	109454	6.4%
t	82596	4.8%
c	81711	4.8%
m	77941	4.5%
Other values (18)	385833	22.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1609941	93.6%
Connector Punctuation	109454	6.4%
Decimal Number	296	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	208749	13.0%
a	206939	12.9%
s	171469	10.7%
o	170145	10.6%
i	114273	7.1%
r	110581	6.9%
t	82596	5.1%
c	81711	5.1%
m	77941	4.8%
n	58609	3.6%
Other values (16)	326928	20.3%

Connector Punctuation

Value	Count	Frequency (%)
_	109454	100.0%

Decimal Number

Value	Count	Frequency (%)
2	296	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1609941	93.6%
Common	109750	6.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	208749	13.0%
a	206939	12.9%
s	171469	10.7%
o	170145	10.6%
i	114273	7.1%
r	110581	6.9%
t	82596	5.1%
c	81711	5.1%
m	77941	4.8%
n	58609	3.6%
Other values (16)	326928	20.3%

Common

Value	Count	Frequency (%)
_	109454	99.7%
2	296	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1719691	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	208749	12.1%
a	206939	12.0%
s	171469	10.0%
o	170145	9.9%
i	114273	6.6%
r	110581	6.4%
_	109454	6.4%
t	82596	4.8%
c	81711	4.8%
m	77941	4.5%
Other values (18)	385833	22.4%

product_name_lenght
Real number (ℝ)

Distinct	66
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.766541

Minimum	5
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	5
5-th percentile	29
Q1	42
median	52
Q3	57
95-th percentile	60
Maximum	76
Range	71
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.034187
Coefficient of variation (CV)	0.20575966
Kurtosis	0.14955291
Mean	48.766541
Median Absolute Deviation (MAD)	6
Skewness	-0.90541969
Sum	5637851
Variance	100.68491
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59	8598	7.4%
60	8004	6.9%
56	6803	5.9%
58	6753	5.8%
57	6261	5.4%
55	5797	5.0%
54	5469	4.7%
53	4319	3.7%
52	4280	3.7%
49	3670	3.2%
Other values (56)	55655	48.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	9	< 0.1%
6	3	< 0.1%
7	2	< 0.1%
8	4	< 0.1%
9	14	< 0.1%
10	8	< 0.1%
11	11	< 0.1%
12	37	< 0.1%
13	26	< 0.1%
14	47	< 0.1%

Value	Count	Frequency (%)
76	1	< 0.1%
72	9	< 0.1%
69	1	< 0.1%
68	1	< 0.1%
67	3	< 0.1%
66	1	< 0.1%
64	170	0.1%
63	1335	1.2%
62	160	0.1%
61	239	0.2%

product_description_lenght
Real number (ℝ)

Distinct	2958
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	785.8082

Minimum	4
Maximum	3992
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	4
5-th percentile	160
Q1	346
median	600
Q3	983
95-th percentile	2120
Maximum	3992
Range	3988
Interquartile range (IQR)	637

Descriptive statistics

Standard deviation	652.41862
Coefficient of variation (CV)	0.83025173
Kurtosis	4.9272446
Mean	785.8082
Median Absolute Deviation (MAD)	295
Skewness	2.011533
Sum	90846500
Variance	425650.05
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
341	708	0.6%
1893	664	0.6%
348	643	0.6%
492	590	0.5%
903	588	0.5%
245	576	0.5%
366	532	0.5%
236	513	0.4%
340	484	0.4%
919	436	0.4%
Other values (2948)	109875	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	6	< 0.1%
8	2	< 0.1%
15	1	< 0.1%
20	7	< 0.1%
23	1	< 0.1%
26	2	< 0.1%
27	4	< 0.1%
28	2	< 0.1%
30	8	< 0.1%
31	2	< 0.1%

Value	Count	Frequency (%)
3992	2	< 0.1%
3988	1	< 0.1%
3985	3	< 0.1%
3976	6	< 0.1%
3963	1	< 0.1%
3956	3	< 0.1%
3954	2	< 0.1%
3950	2	< 0.1%
3949	1	< 0.1%
3948	1	< 0.1%

product_photos_qty
Real number (ℝ)

Distinct	19
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.2053733

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	3
95-th percentile	6
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.717771
Coefficient of variation (CV)	0.7789026
Kurtosis	4.8372556
Mean	2.2053733
Median Absolute Deviation (MAD)	0
Skewness	1.910868
Sum	254961
Variance	2.9507372
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	58429	50.5%
2	22894	19.8%
3	12869	11.1%
4	8770	7.6%
5	5558	4.8%
6	3905	3.4%
7	1552	1.3%
8	771	0.7%
10	353	0.3%
9	309	0.3%
Other values (9)	199	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	58429	50.5%
2	22894	19.8%
3	12869	11.1%
4	8770	7.6%
5	5558	4.8%
6	3905	3.4%
7	1552	1.3%
8	771	0.7%
9	309	0.3%
10	353	0.3%

Value	Count	Frequency (%)
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%
17	11	< 0.1%
15	12	< 0.1%
14	6	< 0.1%
13	30	< 0.1%
12	60	0.1%
11	73	0.1%
10	353	0.3%

product_weight_g
Real number (ℝ)

HIGH CORRELATION

Distinct	2197
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2113.8911

Minimum	0
Maximum	40425
Zeros	8
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	0
5-th percentile	125
Q1	300
median	700
Q3	1800
95-th percentile	9850
Maximum	40425
Range	40425
Interquartile range (IQR)	1500

Descriptive statistics

Standard deviation	3781.7427
Coefficient of variation (CV)	1.788996
Kurtosis	16.034687
Mean	2113.8911
Median Absolute Deviation (MAD)	500
Skewness	3.5806654
Sum	2.4438484 × 10⁸
Variance	14301578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	6816	5.9%
150	5329	4.6%
250	4671	4.0%
300	4313	3.7%
100	3571	3.1%
400	3481	3.0%
350	3211	2.8%
500	2787	2.4%
600	2778	2.4%
700	2095	1.8%
Other values (2187)	76557	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8	< 0.1%
2	5	< 0.1%
25	3	< 0.1%
50	985	0.9%
53	2	< 0.1%
54	2	< 0.1%
55	2	< 0.1%
58	1	< 0.1%
60	9	< 0.1%
61	5	< 0.1%

Value	Count	Frequency (%)
40425	3	< 0.1%
30000	296	0.3%
29800	1	< 0.1%
29750	1	< 0.1%
29700	4	< 0.1%
29600	5	< 0.1%
29500	2	< 0.1%
29250	1	< 0.1%
29150	1	< 0.1%
29100	1	< 0.1%

product_length_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.307779

Minimum	7
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	7
5-th percentile	16
Q1	18
median	25
Q3	38
95-th percentile	62
Maximum	105
Range	98
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	16.211093
Coefficient of variation (CV)	0.53488225
Kurtosis	3.6631492
Mean	30.307779
Median Absolute Deviation (MAD)	8
Skewness	1.7425168
Sum	3503852
Variance	262.79953
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	17713	15.3%
20	10603	9.2%
30	7814	6.8%
17	6126	5.3%
18	5844	5.1%
19	4845	4.2%
25	4768	4.1%
40	4238	3.7%
22	3935	3.4%
50	3091	2.7%
Other values (89)	46632	40.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	32	< 0.1%
8	2	< 0.1%
9	4	< 0.1%
10	8	< 0.1%
11	96	0.1%
12	41	< 0.1%
13	60	0.1%
14	137	0.1%
15	212	0.2%
16	17713	15.3%

Value	Count	Frequency (%)
105	331	0.3%
104	30	< 0.1%
103	45	< 0.1%
102	60	0.1%
101	108	0.1%
100	424	0.4%
99	36	< 0.1%
98	50	< 0.1%
97	11	< 0.1%
96	8	< 0.1%

product_height_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	102
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.638419

Minimum	2
Maximum	105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	13
Q3	20
95-th percentile	45
Maximum	105
Range	103
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	13.473526
Coefficient of variation (CV)	0.80978399
Kurtosis	7.2875923
Mean	16.638419
Median Absolute Deviation (MAD)	6
Skewness	2.2431354
Sum	1923551
Variance	181.53589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	10209	8.8%
20	6796	5.9%
15	6784	5.9%
11	6309	5.5%
12	6196	5.4%
2	5097	4.4%
4	4778	4.1%
8	4773	4.1%
16	4661	4.0%
5	4636	4.0%
Other values (92)	55370	47.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	5097	4.4%
3	2770	2.4%
4	4778	4.1%
5	4636	4.0%
6	3511	3.0%
7	4217	3.6%
8	4773	4.1%
9	3369	2.9%
10	10209	8.8%
11	6309	5.5%

Value	Count	Frequency (%)
105	137	0.1%
104	14	< 0.1%
103	49	< 0.1%
102	10	< 0.1%
100	42	< 0.1%
99	5	< 0.1%
98	3	< 0.1%
97	2	< 0.1%
96	8	< 0.1%
95	22	< 0.1%

product_width_cm
Real number (ℝ)

HIGH CORRELATION

Distinct	95
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.11314

Minimum	6
Maximum	118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	903.3 KiB

Quantile statistics

Minimum	6
5-th percentile	11
Q1	15
median	20
Q3	30
95-th percentile	45
Maximum	118
Range	112
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.755036
Coefficient of variation (CV)	0.50858672
Kurtosis	4.5532615
Mean	23.11314
Median Absolute Deviation (MAD)	6
Skewness	1.7072296
Sum	2672087
Variance	138.18087
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20	12448	10.8%
11	10662	9.2%
15	8964	7.8%
16	8677	7.5%
30	7880	6.8%
12	5590	4.8%
13	5412	4.7%
14	4753	4.1%
18	4122	3.6%
40	4042	3.5%
Other values (85)	43059	37.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6	2	< 0.1%
7	5	< 0.1%
8	29	< 0.1%
9	51	< 0.1%
10	83	0.1%
11	10662	9.2%
12	5590	4.8%
13	5412	4.7%
14	4753	4.1%
15	8964	7.8%

Value	Count	Frequency (%)
118	7	< 0.1%
105	14	< 0.1%
104	1	< 0.1%
103	1	< 0.1%
102	2	< 0.1%
101	2	< 0.1%
100	43	< 0.1%
98	1	< 0.1%
97	1	< 0.1%
95	2	< 0.1%

product_category_name_english
Text

Distinct	71
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	39
Median length	31
Mean length	12.989949
Min length	3

Characters and Unicode

Total characters	1501755
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	housewares
2nd row	housewares
3rd row	housewares
4th row	housewares
5th row	housewares

Value	Count	Frequency (%)
bed_bath_table	11847	10.2%
health_beauty	9944	8.6%
sports_leisure	8942	7.7%
furniture_decor	8743	7.6%
computers_accessories	8105	7.0%
housewares	7331	6.3%
watches_gifts	6161	5.3%
telephony	4692	4.1%
garden_tools	4558	3.9%
auto	4356	3.8%
Other values (61)	40930	35.4%

Most occurring characters

Value	Count	Frequency (%)
e	183852	12.2%
s	141050	9.4%
t	132154	8.8%
o	111010	7.4%
r	105008	7.0%
a	101597	6.8%
_	101311	6.7%
u	77584	5.2%
c	71956	4.8%
i	62806	4.2%
Other values (15)	413427	27.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1400148	93.2%
Connector Punctuation	101311	6.7%
Decimal Number	296	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	183852	13.1%
s	141050	10.1%
t	132154	9.4%
o	111010	7.9%
r	105008	7.5%
a	101597	7.3%
u	77584	5.5%
c	71956	5.1%
i	62806	4.5%
h	59142	4.2%
Other values (13)	353989	25.3%

Connector Punctuation

Value	Count	Frequency (%)
_	101311	100.0%

Decimal Number

Value	Count	Frequency (%)
2	296	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1400148	93.2%
Common	101607	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	183852	13.1%
s	141050	10.1%
t	132154	9.4%
o	111010	7.9%
r	105008	7.5%
a	101597	7.3%
u	77584	5.5%
c	71956	5.1%
i	62806	4.5%
h	59142	4.2%
Other values (13)	353989	25.3%

Common

Value	Count	Frequency (%)
_	101311	99.7%
2	296	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1501755	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	183852	12.2%
s	141050	9.4%
t	132154	8.8%
o	111010	7.4%
r	105008	7.0%
a	101597	6.8%
_	101311	6.7%
u	77584	5.2%
c	71956	4.8%
i	62806	4.2%
Other values (15)	413427	27.5%

review_score
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

5	65374
4	21951
1	14546
3	9718
2	4020

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	115609
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	5

Common Values

Value	Count	Frequency (%)
5	65374	56.5%
4	21951	19.0%
1	14546	12.6%
3	9718	8.4%
2	4020	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	65374	56.5%
4	21951	19.0%
1	14546	12.6%
3	9718	8.4%
2	4020	3.5%

Most occurring characters

Value	Count	Frequency (%)
5	65374	56.5%
4	21951	19.0%
1	14546	12.6%
3	9718	8.4%
2	4020	3.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	115609	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	65374	56.5%
4	21951	19.0%
1	14546	12.6%
3	9718	8.4%
2	4020	3.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	115609	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	65374	56.5%
4	21951	19.0%
1	14546	12.6%
3	9718	8.4%
2	4020	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	115609	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	65374	56.5%
4	21951	19.0%
1	14546	12.6%
3	9718	8.4%
2	4020	3.5%

review_comment_message
Text

Distinct	35177
Distinct (%)	30.4%
Missing	0
Missing (%)	0.0%
Memory size	903.3 KiB

Length

Max length	208
Median length	10
Mean length	35.468545
Min length	1

Characters and Unicode

Total characters	4100483
Distinct characters	205
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28730 ?
Unique (%)	24.9%

Sample

1st row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
2nd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
3rd row	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
4th row	Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.
5th row	Só achei ela pequena pra seis xícaras ,mais é um bom produto

Value	Count	Frequency (%)
no	72661	10.1%
reviews	66703	9.3%
o	22075	3.1%
produto	20487	2.8%
e	19397	2.7%
a	14735	2.0%
de	14075	2.0%
do	12785	1.8%
não	12702	1.8%
que	10115	1.4%
Other values (19330)	453824	63.1%

Most occurring characters

Value	Count	Frequency (%)
	610307	14.9%
e	462494	11.3%
o	405605	9.9%
a	272669	6.6%
r	260310	6.3%
i	225166	5.5%
s	196336	4.8%
t	156573	3.8%
d	145458	3.5%
n	133224	3.2%
Other values (195)	1232341	30.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3129103	76.3%
Space Separator	610307	14.9%
Uppercase Letter	229112	5.6%
Other Punctuation	93611	2.3%
Decimal Number	21346	0.5%
Control	13578	0.3%
Dash Punctuation	943	< 0.1%
Close Punctuation	718	< 0.1%
Open Punctuation	701	< 0.1%
Other Symbol	690	< 0.1%
Other values (5)	374	< 0.1%

Most frequent character per category

Other Symbol

Value	Count	Frequency (%)
👏	241	34.9%
👍	86	12.5%
😍	74	10.7%
°	27	3.9%
😉	22	3.2%
😘	20	2.9%
😆	19	2.8%
😡	18	2.6%
😁	13	1.9%
👎	13	1.9%
Other values (51)	157	22.8%

Lowercase Letter

Value	Count	Frequency (%)
e	462494	14.8%
o	405605	13.0%
a	272669	8.7%
r	260310	8.3%
i	225166	7.2%
s	196336	6.3%
t	156573	5.0%
d	145458	4.6%
n	133224	4.3%
m	124354	4.0%
Other values (40)	746914	23.9%

Uppercase Letter

Value	Count	Frequency (%)
N	75942	33.1%
E	19186	8.4%
O	18074	7.9%
A	16813	7.3%
P	12154	5.3%
R	11806	5.2%
C	9540	4.2%
M	9162	4.0%
S	8085	3.5%
T	7584	3.3%
Other values (31)	40766	17.8%

Other Punctuation

Value	Count	Frequency (%)
.	49261	52.6%
,	27288	29.2%
!	12446	13.3%
/	1787	1.9%
?	1566	1.7%
"	410	0.4%
:	301	0.3%
;	222	0.2%
%	192	0.2%
*	72	0.1%
Other values (5)	66	0.1%

Decimal Number

Value	Count	Frequency (%)
0	4919	23.0%
1	4891	22.9%
2	4095	19.2%
3	1917	9.0%
4	1328	6.2%
5	1223	5.7%
8	921	4.3%
6	877	4.1%
7	717	3.4%
9	458	2.1%

Math Symbol

Value	Count	Frequency (%)
+	88	61.1%
=	27	18.8%
\|	12	8.3%
<	9	6.2%
~	3	2.1%
×	2	1.4%
>	2	1.4%
÷	1	0.7%

Modifier Symbol

Value	Count	Frequency (%)
🏻	34	33.3%
´	26	25.5%
🏼	15	14.7%
🏽	13	12.7%
^	8	7.8%
🏾	4	3.9%
`	2	2.0%

Control

Value	Count	Frequency (%)
	6779	49.9%
	6779	49.9%
	20	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	715	99.6%
]	3	0.4%

Open Punctuation

Value	Count	Frequency (%)
(	695	99.1%
[	6	0.9%

Other Letter

Value	Count	Frequency (%)
º	24	55.8%
ª	19	44.2%

Space Separator

Value	Count	Frequency (%)
	610307	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	943	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	77	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3358258	81.9%
Common	742225	18.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
	610307	82.2%
.	49261	6.6%
,	27288	3.7%
!	12446	1.7%
	6779	0.9%
	6779	0.9%
0	4919	0.7%
1	4891	0.7%
2	4095	0.6%
3	1917	0.3%
Other values (102)	13543	1.8%

Latin

Value	Count	Frequency (%)
e	462494	13.8%
o	405605	12.1%
a	272669	8.1%
r	260310	7.8%
i	225166	6.7%
s	196336	5.8%
t	156573	4.7%
d	145458	4.3%
n	133224	4.0%
m	124354	3.7%
Other values (83)	976069	29.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4038188	98.5%
None	62050	1.5%
Emoticons	245	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	610307	15.1%
e	462494	11.5%
o	405605	10.0%
a	272669	6.8%
r	260310	6.4%
i	225166	5.6%
s	196336	4.9%
t	156573	3.9%
d	145458	3.6%
n	133224	3.3%
Other values (85)	1170046	29.0%

None

Value	Count	Frequency (%)
ã	18253	29.4%
é	11197	18.0%
á	8923	14.4%
ç	7252	11.7%
ó	6189	10.0%
ê	1902	3.1%
í	1714	2.8%
Ó	1543	2.5%
õ	908	1.5%
ú	886	1.4%
Other values (71)	3283	5.3%

Emoticons

Value	Count	Frequency (%)
😍	74	30.2%
😉	22	9.0%
😘	20	8.2%
😆	19	7.8%
😡	18	7.3%
😁	13	5.3%
😊	12	4.9%
😀	8	3.3%
😩	7	2.9%
😃	6	2.4%
Other values (19)	46	18.8%

Auto

Heatmap
Table

	payment_sequential	payment_installments	payment_value	customer_zip_code_prefix	order_item_id	price	freight_value	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	order_status	payment_type	customer_state	review_score
payment_sequential	1.000	-0.177	-0.214	-0.007	-0.007	-0.005	0.016	-0.004	-0.013	-0.004	0.028	0.032	0.011	0.026	0.029	0.229	0.026	0.012
payment_installments	-0.177	1.000	0.396	0.069	0.060	0.317	0.190	0.016	0.033	-0.003	0.198	0.109	0.106	0.125	0.005	0.273	0.032	0.028
payment_value	-0.214	0.396	1.000	0.106	0.257	0.790	0.424	0.024	0.169	-0.012	0.452	0.231	0.306	0.234	0.016	0.021	0.027	0.028
customer_zip_code_prefix	-0.007	0.069	0.106	1.000	-0.009	0.070	0.466	0.016	0.031	0.026	0.026	0.009	0.019	-0.002	0.023	0.033	0.896	0.042
order_item_id	-0.007	0.060	0.257	-0.009	1.000	-0.114	-0.056	-0.022	-0.032	-0.064	0.001	0.008	0.019	-0.003	0.003	0.021	0.003	0.041
price	-0.005	0.317	0.790	0.070	-0.114	1.000	0.435	0.042	0.211	0.028	0.515	0.268	0.328	0.273	0.015	0.014	0.020	0.012
freight_value	0.016	0.190	0.424	0.466	-0.056	0.435	1.000	0.033	0.117	0.010	0.448	0.282	0.284	0.273	0.016	0.010	0.085	0.015
product_name_lenght	-0.004	0.016	0.024	0.016	-0.022	0.042	0.033	1.000	0.073	0.163	0.076	0.060	-0.057	0.066	0.019	0.011	0.013	0.013
product_description_lenght	-0.013	0.033	0.169	0.031	-0.032	0.211	0.117	0.073	1.000	0.111	0.095	-0.020	0.134	-0.081	0.017	0.020	0.027	0.015
product_photos_qty	-0.004	-0.003	-0.012	0.026	-0.064	0.028	0.010	0.163	0.111	1.000	0.003	0.005	-0.080	-0.015	0.013	0.004	0.014	0.016
product_weight_g	0.028	0.198	0.452	0.026	0.001	0.515	0.448	0.076	0.095	0.003	1.000	0.618	0.530	0.619	0.012	0.017	0.028	0.021
product_length_cm	0.032	0.109	0.231	0.009	0.008	0.268	0.282	0.060	-0.020	0.005	0.618	1.000	0.244	0.631	0.015	0.021	0.017	0.018
product_height_cm	0.011	0.106	0.306	0.019	0.019	0.328	0.284	-0.057	0.134	-0.080	0.530	0.244	1.000	0.334	0.016	0.015	0.020	0.018
product_width_cm	0.026	0.125	0.234	-0.002	-0.003	0.273	0.273	0.066	-0.081	-0.015	0.619	0.631	0.334	1.000	0.005	0.019	0.017	0.013
order_status	0.029	0.005	0.016	0.023	0.003	0.015	0.016	0.019	0.017	0.013	0.012	0.015	0.016	0.005	1.000	0.007	0.027	0.131
payment_type	0.229	0.273	0.021	0.033	0.021	0.014	0.010	0.011	0.020	0.004	0.017	0.021	0.015	0.019	0.007	1.000	0.039	0.009
customer_state	0.026	0.032	0.027	0.896	0.003	0.020	0.085	0.013	0.027	0.014	0.028	0.017	0.020	0.017	0.027	0.039	1.000	0.049
review_score	0.012	0.028	0.028	0.042	0.041	0.012	0.015	0.013	0.015	0.016	0.021	0.018	0.018	0.013	0.131	0.009	0.049	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	order_id	customer_id	order_status	payment_sequential	payment_type	payment_installments	payment_value	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category_name_english	review_score	review_comment_message
0	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	1	credit_card	1	18.12	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	housewares	4	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
1	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	3	voucher	1	2.00	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	housewares	4	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
2	e481f51cbdc54678b7cc49136f2d6af7	9ef432eb6251297304e76186b10a928d	delivered	2	voucher	1	18.59	7c396fd4830fd04220f754e42b4e5bff	3149	sao paulo	SP	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-06 11:07:15	29.99	8.72	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	housewares	4	Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente.
3	128e10d95713541c87cd1a2e48201934	a20e8105f23924cd00833fd87daa0831	delivered	1	credit_card	3	37.77	3a51803cc0d012c3b5dc8b7528cb05f7	3366	sao paulo	SP	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-21 20:05:16	29.99	7.78	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	housewares	4	Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente.
4	0e7e841ddf8f8f2de2bad69267ecfbcf	26c7ac168e1433912a51b924fbd34d34	delivered	1	credit_card	1	37.77	ef0996a1a279c26e7ecbd737be23d235	2290	sao paulo	SP	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-08-08 18:37:31	29.99	7.78	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	housewares	5	Só achei ela pequena pra seis xícaras ,mais é um bom produto\r\n
5	bfc39df4f36c3693ff3b63fcbea9e90a	53904ddbea91e1e92b2b3f1d09a7af86	delivered	1	boleto	1	44.09	e781fdcc107d13d865fc7698711cc572	88032	florianopolis	SC	1	87285b34884572647811a353c7ac498a	3504c0cb71d7fa48d967e0e4c94d59d9	2017-10-31 02:14:11	29.99	14.10	utilidades_domesticas	40.0	268.0	4.0	500.0	19.0	8.0	13.0	housewares	3	No reviews
6	6ea2f835b4556291ffdc53fa0b3b95e8	c7340080e394356141681bd4c9b8fe31	delivered	1	credit_card	10	356.12	3e4fd73f1e86b135b9b121d6abbe9597	19400	presidente venceslau	SP	1	be021417a6acb56b9b50d3fd2714baa8	f5f46307a4d15880ca14fab4ad9dfc9b	2017-11-30 00:21:09	339.00	17.12	utilidades_domesticas	48.0	664.0	6.0	14300.0	38.0	34.0	34.0	housewares	1	Inicialmente, na data da compra o produto era para ser entregue até 21/12. Hoje é dia 27/12 e não chegou ainda.
7	82bce245b1c9148f8d19a55b9ff70644	388025bec8128ff20ec1a316ed4dcf02	delivered	1	boleto	1	267.80	f9effeed3df9ae063a58c0759b96f8b2	85804	cascavel	PR	1	a5a0e71a81ae65aa335e71c06261e260	c8417879a15366a17c30af34c798c332	2017-04-27 05:15:56	38.00	15.56	utilidades_domesticas	57.0	698.0	3.0	705.0	34.0	22.0	28.0	housewares	1	No reviews
8	82bce245b1c9148f8d19a55b9ff70644	388025bec8128ff20ec1a316ed4dcf02	delivered	1	boleto	1	267.80	f9effeed3df9ae063a58c0759b96f8b2	85804	cascavel	PR	2	a5a0e71a81ae65aa335e71c06261e260	c8417879a15366a17c30af34c798c332	2017-04-27 05:15:56	38.00	15.56	utilidades_domesticas	57.0	698.0	3.0	705.0	34.0	22.0	28.0	housewares	1	No reviews
9	82bce245b1c9148f8d19a55b9ff70644	388025bec8128ff20ec1a316ed4dcf02	delivered	1	boleto	1	267.80	f9effeed3df9ae063a58c0759b96f8b2	85804	cascavel	PR	3	a5a0e71a81ae65aa335e71c06261e260	c8417879a15366a17c30af34c798c332	2017-04-27 05:15:56	38.00	15.56	utilidades_domesticas	57.0	698.0	3.0	705.0	34.0	22.0	28.0	housewares	1	No reviews

	order_id	customer_id	order_status	payment_sequential	payment_type	payment_installments	payment_value	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category_name_english	review_score	review_comment_message
115599	9980064d9817bacc9e261e7f5fcf3fe5	e30e0257e1c7189e6f6ba4ef151e717c	delivered	1	credit_card	7	145.56	56c8638e7c058b98aae6d74d2dd6ea23	37800	guaxupe	MG	1	ec90895370885d025efeb8e72e7fa699	e7f3bf1ecd8526eb7f3b18059e6716e5	2017-07-18 07:03:41	129.90	15.66	artes_e_artesanato	57.0	283.0	1.0	1200.0	20.0	20.0	16.0	arts_and_craftmanship	5	No reviews
115600	4ec2eea90506ad5dd1284a1a7e4cafee	edb3ca904a6cd3caeecda1f844ebae65	delivered	1	credit_card	1	41.13	0f8dc6a031c49afe5079f92f04c798c3	4317	sao paulo	SP	1	c51fd9478d188180d962c7ecc35b42d0	e819bcfade7b5d88a27325eb6cfd62c5	2018-08-01 10:45:15	29.90	11.23	artes_e_artesanato	44.0	447.0	4.0	2900.0	50.0	10.0	40.0	arts_and_craftmanship	5	Muito bonito, chegou no prazo. Poderiam ter indicado o número do pedido na embalagem para saber!
115601	31a2886d02ad2127bfec204da2e93b66	28738edfba72391be47d697e6e7e5770	delivered	1	credit_card	1	27.20	e839774c9d31569dba47946296e58b33	11035	santos	SP	1	3a96bcbf644a5d390107570628568026	70126eecc6aa1274392a1743866e9678	2018-07-31 10:35:17	19.80	7.40	artes_e_artesanato	53.0	529.0	2.0	325.0	27.0	10.0	14.0	arts_and_craftmanship	5	Chegou muito, muito antes do prazo
115602	1c3f752b9a4d09bf1e016439a427d5f8	7fe022a904d647429c6e08a8f34c9b22	delivered	1	debit_card	1	23.88	931a4a1a3e2cf8b4b4d33922f1469dbe	12243	sao jose dos campos	SP	1	56a1efb30499b4dffd45c8d655199b11	55f7a3319d80f7fdf078b8f03e6725fe	2018-08-20 23:35:14	16.49	7.39	artes_e_artesanato	60.0	778.0	2.0	100.0	22.0	2.0	15.0	arts_and_craftmanship	5	No reviews
115603	2cfc3681e512e0d12b6fe84b396e3907	6c60b00bcbef919c1697d18c309a99fe	delivered	1	credit_card	1	34.22	4637328fb3cc446c747c7f83f80c651d	38401	uberlandia	MG	1	1cf657de01c2b973b898ad0ac9073ac7	fd386aa7bed2af3c7035c65506c9b4a3	2018-04-26 21:31:05	15.99	18.23	artes_e_artesanato	41.0	130.0	1.0	210.0	25.0	10.0	15.0	arts_and_craftmanship	4	No reviews
115604	0b82d0616f1ad8da15cf967b984b4004	986632b40c38f4240caf8608cb01d40d	delivered	1	boleto	1	33.69	c887bc0b0717ee4a21d7d22137f12ee3	30575	belo horizonte	MG	1	4a24717893a6c8f3cfcf9843b8987d15	2cb6eb1b7185064167657fa09f541105	2018-08-07 04:25:14	25.00	8.69	artes_e_artesanato	36.0	576.0	5.0	350.0	32.0	2.0	28.0	arts_and_craftmanship	5	No reviews
115605	2ef4a11b6e24fdfbb43b92cb5f95edff	ee1cfdc92e449920e25d3ca4ab4da4f6	delivered	1	credit_card	1	84.63	8d80e477643ec569b24592ce3d9dfc4c	9951	diadema	SP	1	9c313adb4b38a55b092f53f83f78be9e	ef728fa1f17436c91ed1ccd03dcf9631	2018-07-30 09:17:39	19.00	12.86	artes_e_artesanato	32.0	660.0	3.0	500.0	16.0	6.0	16.0	arts_and_craftmanship	3	Um dos frisadores que comprei, especificamente a FOLHA NAO FRISA! NAO REALIZA SUA FUNÇAO. Nao molda o eva, Testei com varios materiais diferentes e infelizmente nao funciona.
115606	2ef4a11b6e24fdfbb43b92cb5f95edff	ee1cfdc92e449920e25d3ca4ab4da4f6	delivered	1	credit_card	1	84.63	8d80e477643ec569b24592ce3d9dfc4c	9951	diadema	SP	2	eacb104882d39ffb53140b1d1860a7c3	ef728fa1f17436c91ed1ccd03dcf9631	2018-07-30 09:17:39	39.90	12.87	artes_e_artesanato	57.0	942.0	5.0	500.0	21.0	7.0	14.0	arts_and_craftmanship	3	Um dos frisadores que comprei, especificamente a FOLHA NAO FRISA! NAO REALIZA SUA FUNÇAO. Nao molda o eva, Testei com varios materiais diferentes e infelizmente nao funciona.
115607	2c4ada2e75c2ad41dd93cebb5df5f023	363d3a9b2ec5c5426608688ca033292d	delivered	1	credit_card	1	209.06	d8bee9ec375c3a0f9ef8ed7456a51dcd	76940	rolim de moura	RO	1	6c7a0a349ad11817745e3ad58abd5c79	48162d548f5b1b11b9d29d1e01f75a61	2017-01-30 11:09:00	183.29	25.77	seguros_e_servicos	55.0	506.0	1.0	1225.0	27.0	35.0	15.0	security_and_services	4	Envio muito rápido. Recomendo.
115608	bede3503afed051733eeb4a84d1adcc5	919570a26efbd068d6a0f66d5c5072a3	delivered	1	boleto	1	115.45	141e824b8e0df709e3fcf6d982225a8e	71940	brasilia	DF	1	8db75af9aed3315374db44d7860e25da	4e922959ae960d389249c378d1c939f5	2017-09-26 04:05:52	100.00	15.45	seguros_e_servicos	48.0	461.0	4.0	400.0	26.0	22.0	11.0	security_and_services	1	boa tarde produto enviado errado, terei que me deslocar aos correios pois moro em um condomínio tive receber, e ainda irei esperar chegar para so depois eu receber o produto correto, paguei via boleto

Most frequently occurring

	order_id	customer_id	order_status	payment_sequential	payment_type	payment_installments	payment_value	customer_unique_id	customer_zip_code_prefix	customer_city	customer_state	order_item_id	product_id	seller_id	shipping_limit_date	price	freight_value	product_category_name	product_name_lenght	product_description_lenght	product_photos_qty	product_weight_g	product_length_cm	product_height_cm	product_width_cm	product_category_name_english	review_score	review_comment_message	# duplicates
245	df56136b8031ecd28e200bb18e6ddb2e	b7770073b02ed1d626a027ce86a4ff82	delivered	1	boleto	1	204.72	2e43e031f10de28e557c35ef668f9396	92410	canoas	RS	1	f28cbd414cd06f1ae84065c8dd8be834	4da0e408c99d2fdc2126dc9fce518060	2017-01-30 13:15:41	23.90	2.53	esporte_lazer	60.0	806.0	1.0	700.0	20.0	12.0	16.0	sports_leisure	5	No reviews	3
246	df56136b8031ecd28e200bb18e6ddb2e	b7770073b02ed1d626a027ce86a4ff82	delivered	1	boleto	1	204.72	2e43e031f10de28e557c35ef668f9396	92410	canoas	RS	2	50aa8f292a9510d5542f2a078903a2a7	834f8533b2ecb6598dd004ff3de7203a	2017-01-30 13:15:41	63.92	15.82	esporte_lazer	49.0	1141.0	2.0	400.0	19.0	11.0	37.0	sports_leisure	5	No reviews	3
247	df56136b8031ecd28e200bb18e6ddb2e	b7770073b02ed1d626a027ce86a4ff82	delivered	1	boleto	1	204.72	2e43e031f10de28e557c35ef668f9396	92410	canoas	RS	3	3025303c80b01a0926fda2841cc31b4a	4da0e408c99d2fdc2126dc9fce518060	2017-01-30 13:15:41	66.90	31.65	esporte_lazer	56.0	222.0	2.0	2100.0	40.0	25.0	28.0	sports_leisure	5	No reviews	3
0	0176a6846bcb3b0d3aa3116a9a768597	aaad67429ea7d339bdf5f71ae3ef74f6	delivered	1	boleto	1	53.68	13613cae6e3bfea8327a916246c96cc9	5108	sao paulo	SP	1	19421075ae0b585f2dc13ff149e2119d	4c2b230173bb36f9b240f2b8ac11786e	2018-01-03 04:32:07	45.90	7.78	esporte_lazer	32.0	1797.0	1.0	150.0	16.0	16.0	11.0	sports_leisure	5	No reviews	2
1	03515a836bb855b03f7df9dee520a8fc	153e6d880db3cac30ecfeb13e0047841	delivered	1	credit_card	10	106.38	159306b86e782097be9a4e29e3d294d3	95540	palmares do sul	RS	1	2b4609f8948be18874494203496bc318	cc419e0650a3c5ba77189a1882b7556a	2018-01-29 13:36:01	89.99	16.39	beleza_saude	59.0	492.0	3.0	250.0	22.0	10.0	18.0	health_beauty	5	No reviews	2
2	05452881e2846549b81d39249bb66ad7	1ff911e9682875f08a0f44bad0807455	delivered	1	credit_card	8	224.60	744fb2d41ededa16d3f703b7065b234c	2215	sao paulo	SP	1	283dc451ad3918badb976d56ff887289	da8622b14eb17ae2831f4ac5b9dab84a	2018-02-11 22:35:33	99.90	12.40	cama_mesa_banho	58.0	188.0	1.0	1650.0	44.0	2.0	35.0	bed_bath_table	5	No reviews	2
3	05452881e2846549b81d39249bb66ad7	1ff911e9682875f08a0f44bad0807455	delivered	1	credit_card	8	224.60	744fb2d41ededa16d3f703b7065b234c	2215	sao paulo	SP	2	283dc451ad3918badb976d56ff887289	da8622b14eb17ae2831f4ac5b9dab84a	2018-02-11 22:35:33	99.90	12.40	cama_mesa_banho	58.0	188.0	1.0	1650.0	44.0	2.0	35.0	bed_bath_table	5	No reviews	2
4	056bfadd41b8600ad5ecfef2ac132188	91faeb032f47277f654a8202eaa9fed6	delivered	1	credit_card	3	35.01	2106e7aa97e2b0bb0193c9f2478d85e0	9895	sao bernardo do campo	SP	1	2bb67f2cd3ff60400e0bad33aee72d2a	daeb5653dd96c1b11860f72209795012	2017-11-30 11:15:31	19.90	15.11	brinquedos	49.0	872.0	1.0	550.0	40.0	10.0	30.0	toys	4	No reviews	2
5	06b2c7035561ef12b16045ef4bf459e2	8bb9547aec97f493e91a078f66fa7ac5	delivered	1	credit_card	6	68.02	630331e73a79ae9a2ba821bd326ea298	88850	forquilhinha	SC	1	f7a17d2c51d9df89a4f1711c4ac17f33	f8db351d8c4c4c22c6835c19a46f01b0	2017-07-11 17:28:03	52.90	15.12	utilidades_domesticas	56.0	1245.0	5.0	350.0	22.0	8.0	19.0	housewares	5	No reviews	2
6	0715dfcf2383aa72c181d8b47f6cb589	0ea00ae539e6a29390c4e1d0841352e4	delivered	1	credit_card	3	97.02	b0ac5b393b78a6e8185fd3acb154748d	99150	marau	RS	1	9b4d597238711e4dfc04d98bb2e5ed17	7681ef142fd2c19048da7430856b5588	2018-02-20 10:55:31	76.00	21.02	industria_comercio_e_negocios	58.0	1553.0	4.0	5200.0	38.0	30.0	25.0	industry_commerce_and_business	5	No reviews	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block